EBS Data Intelligence Analytics Tables
Reference documentation for EBS Data Intelligence Analytics warehouse tables. Select a module and table to review its documented columns, data types, nullability, descriptions, and referenced tables.
Modules
Payables (EBS_AP)
- DW_EB_X_EBS_AP_W_AP_AGING_BUCKETS_D
- DW_EB_X_EBS_AP_W_AP_AGING_INVOICE_A
- DW_EB_X_EBS_AP_W_AP_AGING_INVOICE_ENT_A
- DW_EB_X_EBS_AP_W_AP_AGING_SUPPLIER_A
- DW_EB_X_EBS_AP_W_AP_AGING_SUPPLIER_ENT_A
- DW_EB_X_EBS_AP_W_AP_AGN_INV_BKP_A
- DW_EB_X_EBS_AP_W_AP_AGN_INV_ENT_BKP_A
- DW_EB_X_EBS_AP_W_AP_BALANCE_ENT_F
- DW_EB_X_EBS_AP_W_AP_BALANCE_F
- DW_EB_X_EBS_AP_W_AP_HOLD_RELEASE_REASON_D
- DW_EB_X_EBS_AP_W_AP_HOLDS_F
- DW_EB_X_EBS_AP_W_AP_XACT_F
- DW_EB_X_EBS_AP_W_AP_XACT_GRPACCT_DAY_A
- DW_EB_X_EBS_AP_W_AP_XACT_GRPACCT_FSCLPRD_A
Receivables (EBS_AR)
- DW_EB_X_EBS_AR_W_AR_AGING_BUCKETS_D
- DW_EB_X_EBS_AR_W_AR_AGING_CUSTOMER_A
- DW_EB_X_EBS_AR_W_AR_AGING_CUSTOMER_ENT_A
- DW_EB_X_EBS_AR_W_AR_AGING_INVOICE_A
- DW_EB_X_EBS_AR_W_AR_AGING_INVOICE_ENT_A
- DW_EB_X_EBS_AR_W_AR_AGN_INV_BKP_A
- DW_EB_X_EBS_AR_W_AR_AGN_INV_ENT_BKP_A
- DW_EB_X_EBS_AR_W_AR_BALANCE_ENT_F
- DW_EB_X_EBS_AR_W_AR_BALANCE_F
- DW_EB_X_EBS_AR_W_AR_XACT_F
- DW_EB_X_EBS_AR_W_AR_XACT_GRPACCT_DAY_A
- DW_EB_X_EBS_AR_W_AR_XACT_GRPACCT_FSCLPRD_A
- DW_EB_X_EBS_AR_W_CONTRACT_HDR_D
- DW_EB_X_EBS_AR_W_CONTRACT_HDR_D_TL
- DW_EB_X_EBS_AR_W_CUSTOMER_FIN_PROFL_F
Common Tables (EBS_COMMON)
- DW_EB_X_EBS_COMMON_W_ACCGEOSTATE_D
- DW_EB_X_EBS_COMMON_W_AP_TERMS_D
- DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D
- DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_DH
- DW_EB_X_EBS_COMMON_W_BANK_D
- DW_EB_X_EBS_COMMON_W_BIEE_CURR_CODE_LKP
- DW_EB_X_EBS_COMMON_W_BUDGET_D
- DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D
- DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D_TL
- DW_EB_X_EBS_COMMON_W_CHNL_TYPE_D
- DW_EB_X_EBS_COMMON_W_CONTRACT_LINE_D
- DW_EB_X_EBS_COMMON_W_CONTRACT_LINE_D_TL
- DW_EB_X_EBS_COMMON_W_COST_CENTER_D
- DW_EB_X_EBS_COMMON_W_COST_CENTER_DH
- DW_EB_X_EBS_COMMON_W_CTRY_REGN_D
- DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D
- DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D
- DW_EB_X_EBS_COMMON_W_DATE_RANGE_G
- DW_EB_X_EBS_COMMON_W_DAY_D
- DW_EB_X_EBS_COMMON_W_DUAL_G
- DW_EB_X_EBS_COMMON_W_EMPLOYEE_ADDL_D
- DW_EB_X_EBS_COMMON_W_EMPLOYEE_D
- DW_EB_X_EBS_COMMON_W_ENT_PERIOD_D
- DW_EB_X_EBS_COMMON_W_ENT_QTR_D
- DW_EB_X_EBS_COMMON_W_ENT_WEEK_D
- DW_EB_X_EBS_COMMON_W_ENT_YEAR_D
- DW_EB_X_EBS_COMMON_W_EXCH_RATE_G
- DW_EB_X_EBS_COMMON_W_FINANCIAL_RESOURCE_D
- DW_EB_X_EBS_COMMON_W_GEO_COUNTRY_D
- DW_EB_X_EBS_COMMON_W_GEO_D
- DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D
- DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_MAP_G
- DW_EB_X_EBS_COMMON_W_GL_DATASET_SEC_D
- DW_EB_X_EBS_COMMON_W_GL_GROUP_ACCOUNT_D
- DW_EB_X_EBS_COMMON_W_GL_LINKAGE_INFORMATION_G
- DW_EB_X_EBS_COMMON_W_GL_OTHER_F
- DW_EB_X_EBS_COMMON_W_GL_OTHER_GRPACCOUNT_A_TMP
- DW_EB_X_EBS_COMMON_W_GL_OTHER_GRPACCT_DAY_A
- DW_EB_X_EBS_COMMON_W_GL_OTHER_GRPACCT_FSCLPRD_A
- DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D
- DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D_TL
- DW_EB_X_EBS_COMMON_W_GL_SEGMENT_DH
- DW_EB_X_EBS_COMMON_W_GL_SEGMENT_LOV_ID_G
- DW_EB_X_EBS_COMMON_W_GLOBAL_CURR_G
- DW_EB_X_EBS_COMMON_W_GLOBAL_EXCH_RATE_G
- DW_EB_X_EBS_COMMON_W_INDUSTRY_D_TL
- DW_EB_X_EBS_COMMON_W_INDUSTRY_DH
- DW_EB_X_EBS_COMMON_W_INT_ORG_D
- DW_EB_X_EBS_COMMON_W_INT_ORG_D_TL
- DW_EB_X_EBS_COMMON_W_INT_ORG_DH
- DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D
- DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D_TL
- DW_EB_X_EBS_COMMON_W_ITEM_COST_G
- DW_EB_X_EBS_COMMON_W_LEDGER_D
- DW_EB_X_EBS_COMMON_W_LEDGER_MAP_G
- DW_EB_X_EBS_COMMON_W_MCAL_CAL_D
- DW_EB_X_EBS_COMMON_W_MCAL_CONFIG_G
- DW_EB_X_EBS_COMMON_W_MCAL_CONTEXT_G
- DW_EB_X_EBS_COMMON_W_MCAL_DAY_D
- DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D
- DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_MAP_G
- DW_EB_X_EBS_COMMON_W_MCAL_QTR_D
- DW_EB_X_EBS_COMMON_W_MCAL_WEEK_D
- DW_EB_X_EBS_COMMON_W_MCAL_YEAR_D
- DW_EB_X_EBS_COMMON_W_MFG_RESOURCE_D
- DW_EB_X_EBS_COMMON_W_MONTH_D
- DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_D
- DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_DH
- DW_EB_X_EBS_COMMON_W_PARTY_D
- DW_EB_X_EBS_COMMON_W_PARTY_ORG_ADDL_ATTR_D
- DW_EB_X_EBS_COMMON_W_PARTY_ORG_ADDL_D
- DW_EB_X_EBS_COMMON_W_PARTY_ORG_D
- DW_EB_X_EBS_COMMON_W_PARTY_ORG_DH
- DW_EB_X_EBS_COMMON_W_PARTY_PER_ADDL_D
- DW_EB_X_EBS_COMMON_W_PARTY_PER_D
- DW_EB_X_EBS_COMMON_W_PAYMENT_METHOD_D
- DW_EB_X_EBS_COMMON_W_PAYMENT_TERMS_D
- DW_EB_X_EBS_COMMON_W_POSITION_D
- DW_EB_X_EBS_COMMON_W_POSITION_DH
- DW_EB_X_EBS_COMMON_W_POSTED_SLENTRY_G
- DW_EB_X_EBS_COMMON_W_PROD_CAT_DH
- DW_EB_X_EBS_COMMON_W_PROD_LN_D
- DW_EB_X_EBS_COMMON_W_PRODUCT_ADDL_ATTR_D
- DW_EB_X_EBS_COMMON_W_PRODUCT_CATALOG_D
- DW_EB_X_EBS_COMMON_W_PRODUCT_D
- DW_EB_X_EBS_COMMON_W_PRODUCT_D_TL
- DW_EB_X_EBS_COMMON_W_PRODUCT_DH
- DW_EB_X_EBS_COMMON_W_PRODUCT_GROUP_ADDL_D
- DW_EB_X_EBS_COMMON_W_PRODUCT_TYPE_D
- DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D
- DW_EB_X_EBS_COMMON_W_PROJ_CLASSIFICATION_D
- DW_EB_X_EBS_COMMON_W_PROJECT_D
- DW_EB_X_EBS_COMMON_W_PROJECT_D_TL
- DW_EB_X_EBS_COMMON_W_PROJECT_DH
- DW_EB_X_EBS_COMMON_W_PROJECT_ROLE_D
- DW_EB_X_EBS_COMMON_W_QTR_D
- DW_EB_X_EBS_COMMON_W_REASON_D
- DW_EB_X_EBS_COMMON_W_SALES_PRODUCT_D
- DW_EB_X_EBS_COMMON_W_STATUS_D
- DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D
- DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D
- DW_EB_X_EBS_COMMON_W_TASK_D
- DW_EB_X_EBS_COMMON_W_TASK_DH
- DW_EB_X_EBS_COMMON_W_TREASURY_SYMBOL_D
- DW_EB_X_EBS_COMMON_W_UNSPSC_FILE_DATA_G
- DW_EB_X_EBS_COMMON_W_UOM_CONVERSION_G
- DW_EB_X_EBS_COMMON_W_USER_D
- DW_EB_X_EBS_COMMON_W_WEEK_D
- DW_EB_X_EBS_COMMON_W_XACT_SOURCE_D
- DW_EB_X_EBS_COMMON_W_XACT_TYPE_D
- DW_EB_X_EBS_COMMON_W_YEAR_D
Domains (EBS_DOMAINS)
Employee Expense (EBS_EE)
Fixed Assets (EBS_FA)
- DW_EB_X_EBS_FA_W_ASSET_BOOK_D
- DW_EB_X_EBS_FA_W_ASSET_CATEGORY_D
- DW_EB_X_EBS_FA_W_ASSET_CATEGORY_D_TL
- DW_EB_X_EBS_FA_W_ASSET_LEASE_D
- DW_EB_X_EBS_FA_W_ASSET_LOCATION_D
- DW_EB_X_EBS_FA_W_FA_BALANCE_F
- DW_EB_X_EBS_FA_W_FA_LEASE_PAYMENT_F
- DW_EB_X_EBS_FA_W_FA_XACT_F
- DW_EB_X_EBS_FA_W_FA_XACT_GRPACCT_FSCLPRD_A
- DW_EB_X_EBS_FA_W_FIXED_ASSET_D
- DW_EB_X_EBS_FA_W_FIXED_ASSET_D_TL
General Ledger (EBS_GL)
Profitability (EBS_PR)
- DW_EB_X_EBS_PR_W_CST_COST_ORG_BOOK_D
- DW_EB_X_EBS_PR_W_CUSTOMER_COST_LINE_F
- DW_EB_X_EBS_PR_W_GL_COGS_F
- DW_EB_X_EBS_PR_W_GL_COGS_GRPACCT_DAY_A
- DW_EB_X_EBS_PR_W_GL_COGS_GRPACCT_FSCLPRD_A
- DW_EB_X_EBS_PR_W_GL_REVN_F
- DW_EB_X_EBS_PR_W_GL_REVN_GRPACCT_DAY_A
- DW_EB_X_EBS_PR_W_GL_REVN_GRPACCT_FSCLPRD_A
- DW_EB_X_EBS_PR_W_PRODUCT_COST_LINE_F
- DW_EB_X_EBS_PR_W_TERR_D
Procurement (EBS_PROC)
- DW_EB_X_EBS_PROC_W_AP_INV_DIST_F
- DW_EB_X_EBS_PROC_W_AP_INV_DIST_MONTH_A
- DW_EB_X_EBS_PROC_W_MVMNT_TYPE_D
- DW_EB_X_EBS_PROC_W_NEG_AWARDS_F
- DW_EB_X_EBS_PROC_W_NEG_INVITATIONS_F
- DW_EB_X_EBS_PROC_W_NEG_LINES_F
- DW_EB_X_EBS_PROC_W_NEG_RESPONSES_F
- DW_EB_X_EBS_PROC_W_PROC_PROD_D
- DW_EB_X_EBS_PROC_W_PURCH_AGREEMENT_HEADER_F
- DW_EB_X_EBS_PROC_W_PURCH_AGREEMENT_LINE_F
- DW_EB_X_EBS_PROC_W_PURCH_COST_F
- DW_EB_X_EBS_PROC_W_PURCH_CYCLE_LINE_A
- DW_EB_X_EBS_PROC_W_PURCH_CYCLE_LINE_F
- DW_EB_X_EBS_PROC_W_PURCH_RCPT_A
- DW_EB_X_EBS_PROC_W_PURCH_RCPT_F
- DW_EB_X_EBS_PROC_W_PURCH_RQSTN_LINE_F
- DW_EB_X_EBS_PROC_W_PURCH_SCHEDULE_LINE_F
- DW_EB_X_EBS_PROC_W_PURCH_TARGET_F
- DW_EB_X_EBS_PROC_W_PURCH_VARIANCE_XACT_F
- DW_EB_X_EBS_PROC_W_RQSTN_LINE_COST_F
Projects (EBS_PROJECTS)
- DW_EB_X_EBS_PROJECTS_W_AWARD_BUD_CATG_D
- DW_EB_X_EBS_PROJECTS_W_AWARD_D
- DW_EB_X_EBS_PROJECTS_W_AWARD_D_TL
- DW_EB_X_EBS_PROJECTS_W_AWARD_INSTN_D
- DW_EB_X_EBS_PROJECTS_W_AWARD_KEYWORD_D
- DW_EB_X_EBS_PROJECTS_W_AWARD_SPONSOR_D
- DW_EB_X_EBS_PROJECTS_W_COMPETENCY_RATING_D
- DW_EB_X_EBS_PROJECTS_W_COMPETENCY_RATING_D_TL
- DW_EB_X_EBS_PROJECTS_W_EMP_COMPETENCY_F
- DW_EB_X_EBS_PROJECTS_W_EMP_JOB_F
- DW_EB_X_EBS_PROJECTS_W_EMPLOYMENT_D
- DW_EB_X_EBS_PROJECTS_W_EVENT_D
- DW_EB_X_EBS_PROJECTS_W_HOLIDAY_CAL_D
- DW_EB_X_EBS_PROJECTS_W_HOLIDAY_DAY_D
- DW_EB_X_EBS_PROJECTS_W_HOLIDAY_PRJ_CONTEXT_G
- DW_EB_X_EBS_PROJECTS_W_JOB_D
- DW_EB_X_EBS_PROJECTS_W_JOB_D_TL
- DW_EB_X_EBS_PROJECTS_W_PROJ_ASSET_D
- DW_EB_X_EBS_PROJECTS_W_PROJ_ASSET_D_TL
- DW_EB_X_EBS_PROJECTS_W_PROJ_ASSIGNMENT_D
- DW_EB_X_EBS_PROJECTS_W_PROJ_AVLBL_BUCKETS_D
- DW_EB_X_EBS_PROJECTS_W_PROJ_AWARD_DEPT_H
- DW_EB_X_EBS_PROJECTS_W_PROJ_AWARD_KEYWORD_H
- DW_EB_X_EBS_PROJECTS_W_PROJ_BUDGET_D
- DW_EB_X_EBS_PROJECTS_W_PROJ_BUDGET_D_TL
- DW_EB_X_EBS_PROJECTS_W_PROJ_BUDGET_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_CAPITAL_EVENT_D
- DW_EB_X_EBS_PROJECTS_W_PROJ_CIP_DTL_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_CIP_HDR_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_COMMITMENT_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_COMMITMENT_SNP_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_COMPETENCY_D
- DW_EB_X_EBS_PROJECTS_W_PROJ_COMPETENCY_D_TL
- DW_EB_X_EBS_PROJECTS_W_PROJ_CONTRACT_LINE_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_COST_A
- DW_EB_X_EBS_PROJECTS_W_PROJ_COST_LINE_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_CROSS_CHARGE_DIST_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_EXP_LINE_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_FORECAST_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_FUNDING_HDR_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_FUNDING_LINE_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_GL_RECNCLIATION_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_INVOICE_DIST_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_INVOICE_LINE_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_RETENTION_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_REVENUE_A
- DW_EB_X_EBS_PROJECTS_W_PROJ_REVENUE_HDR_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_REVENUE_LINE_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_RQMNT_COMPETENCY_H
- DW_EB_X_EBS_PROJECTS_W_PROJ_RSRC_RQRMNT_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_RSRC_UTILIZATION_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_STATUS_CRNT_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_STATUS_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_STATUS_MNTH_SNP_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_STATUS_QTR_SNP_F
- DW_EB_X_EBS_PROJECTS_W_PROJ_STATUS_YR_SNP_F
- DW_EB_X_EBS_PROJECTS_W_VENDOR_D
- DW_EB_X_EBS_PROJECTS_W_WORK_TYPE_D